<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=UTF-8">
	<TITLE></TITLE>
	<META NAME="GENERATOR" CONTENT="OpenOffice.org 3.2  (Win32)">
	<META NAME="AUTHOR" CONTENT="Exson Qu">
	<META NAME="CREATED" CONTENT="20110221;11293100">
	<META NAME="CHANGEDBY" CONTENT="Exson Qu">
	<META NAME="CHANGED" CONTENT="20110221;17343100">
	<STYLE TYPE="text/css">
	<!--
		@page { margin: 2cm }
		P { margin-bottom: 0.21cm }
	-->
	</STYLE>
</HEAD>
<BODY LANG="zh-CN" DIR="LTR">
<P STYLE="margin-bottom: 0.5cm"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=5 STYLE="font-size: 20pt"><B>销售分析</B></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>有几种方法分析销售历史。如果需要一个快速分析，</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>webERP</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>的销售图表脚本很灵活性，允许用图来反映销售与预算。当然，它依赖销售预算记录的水平以及与预算比较是否会显示一些有用的信息。如果需要实际数字的报告，</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">webER</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>有一个销售报告生成工具，来创建销售报告－－得到的报告模板可以重新运行或者修改。这些报告可以输出</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">pdf</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>或者</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">csv</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件，</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>csv</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件可以被大多数的试算表程序读取。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>从主菜单，在应收账款模块的报告和查询选项中有&ldquo;销售分析报告&rdquo;。所有预先定义的销售报告在这里都有链接以进行：</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>修改报告的设计－－标题</FONT></FONT>
		</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>修改报告的列
	</FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>运行报告并生成一个</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">PDF</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件</FONT></FONT></P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>运行报告并创建</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">CSV</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>他用</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>逗号分隔值，可以被任何的试算表程序读取</FONT></FONT>。</P>
</UL>
<P><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在这页面下方，也可以创建新报告来显示销售数据的综合信息。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>webERP</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>将销售数据以单独的表维护，以使这些报告以最快的速度运行。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><BR><BR>
</P>
<P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>销售分析报告的组成：</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告标题的定义
	</FONT></FONT>
	</P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告列的定义</FONT></FONT></P>
</UL>
<P><BR><BR>
</P>
<P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=5 STYLE="font-size: 20pt"><B>销售分析报告标题</B></FONT></FONT></P>
<DIV ID="mfvr" DIR="LTR">
	<P ALIGN=LEFT><IMG SRC="https://docs.google.com/File?id=dcs8sft2_135fbt95m92_b" NAME="图形1" ALIGN=BOTTOM WIDTH=679 HEIGHT=337 BORDER=0></P>
</DIV>
<P><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>创建报告的第一步是输入标题信息，包括：</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告标题－－描述报告的任意字符组合。</FONT></FONT>
		</P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>最多４层分组和每组的条件</FONT></FONT></P>
</UL>
<P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>每个组别包含下面选择中的一种：</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>销售区域
	</FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>产品代码
	</FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>顾客代码－－实际的付款帐户
	</FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>销售类型（价格表）</FONT></FONT>
		</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>产品类型（或者存货</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/</SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>库存目录）
	</FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>顾客分公司</FONT></FONT></P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>销售人员</FONT></FONT></P>
</UL>
<P><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告按照顺序对每个水平来进行分组</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">.
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>例如</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>把第一组设置成产品代码</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">,
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>第二组</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>设置成销售地区，那么报告就会显示产品的代码，然后是在此产品代码下，产品销售的地区，也就是说这个产品是在哪里里出售的。通常，更合理的顺序可能是将销售地区</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>作为第一组，</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>产品代码作为第二组</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">,
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>这样每个地区销售的所有产品的代码出现在一起。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>每个</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分组都</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>要求指定一个范围。所有指定的条件必须指向相关组别在</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><B>设置模块</B></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>指定的编码。例如，销售地区条件必须输入地区编码－－而不是地区描述。起始条件必须小于终止条件，否则报告将会没有输出。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><B><BR></B></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=5 STYLE="font-size: 20pt"><B>销售分析报告列</B></FONT></FONT></P>
<DIV ID="t4zf" DIR="LTR">
	<P ALIGN=LEFT><IMG SRC="https://docs.google.com/File?id=dcs8sft2_136hkt4ztdx_b" NAME="图形2" ALIGN=BOTTOM WIDTH=648 HEIGHT=331 BORDER=0></P>
</DIV>
<P><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在为报告创建了标题之后，我们就可以定义列了。已有报告的列可以在任何时间修改。从销售分析报告主页面</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">-</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>（应收帐款－销售分析报告）－－在每个报告都有一个链接
</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>定义列&rdquo;。点击这个链接，所选择的报告列就会出现，同时还显示一个表格允许输入新的列。对定义的每个栏位而言，下面的输入是必须的：</FONT></FONT></P>
<UL>
	<P STYLE="margin-bottom: 0cm"></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">1</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>到</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">10</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>之间的列号。这些数字决定了在整个页中，这个列的打印位置－</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">1</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>是最近页面左侧的列，</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">10</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>是最近右侧的列。</FONT></FONT></P>
	<P STYLE="margin-bottom: 0cm"></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>有两个栏位用来输入列标题的第一行和第二行。每个栏位可以输入最多</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">15</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>个任意字符。</FONT></FONT></P>
	<P STYLE="margin-bottom: 0cm"></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>列是否是计算结果。计算列的输入要求与正常数据列的是不同的。</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>对正常的数据列－－需要来显示数据的期间范围。期间的起止必须以期间的数字指定。由于期间由系统以几乎不可见的方式维护，这个屏幕提供了一个链接显示定义的期间。如果要求期间为单个月，那么期间的起始止是相同的。
	</FONT></FONT>
	</P>
	<P STYLE="margin-bottom: 0cm"></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>显示在列中的数据可以从下列选择：数量，毛值</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">,</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>净值（扣除折扣），毛利润，成本和折扣。</FONT></FONT></P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>预算的销售或者实际的销售。</FONT></FONT></P>
</UL>
<P><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>如果这列被定义为计算，并不要求期间的范围，也不要求选择数据的类型，预算或实际。把计算字段的设置改为</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">yes</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，是，然后点击输入信息按钮，显示对于计算所要求的字段：</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子字段－－这是要计算的第一个参数的列号－分子字段在计算中总是被要求的。</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分母字段</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">--</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>如果计算是在两列间进行的话，这是用于计算的第二个栏位参数。如果计算的运算符为除法</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN LANG="en-US">--</SPAN></SPAN></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><FONT COLOR="#000000">那么这列将全部会出现在除法的分母</FONT>。如果计算是用常数的话，这个字段将留为空白。</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>运算符可以是其中之一：
	</FONT></FONT>
	</P>
	<OL>
		<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子栏被分母栏除
		</FONT></FONT>
		</P>
		<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子栏被常数整除
		</FONT></FONT>
		</P>
		<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子栏被常数相乘
		</FONT></FONT>
		</P>
		<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子栏加分母栏
		</FONT></FONT>
		</P>
		<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>分子栏减去分母栏</FONT></FONT></P>
	</OL>
	<LI><P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在计算中，常数可以是任何的数字。
	</FONT></FONT>
	</P>
	<LI><P><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>计算结果的格式可以表示为百分数或者数字。</FONT></FONT></P>
</UL>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点击输入信息按纽将此列加入到定义的报表中。它应该显示在定义的列列表中。并显示一个用于定义新列的一个空白表格。如果不需要新的列位，列位定义的列表有一个链接允许删除相关列。</FONT></FONT></P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>列数本身是一个用来修改栏位定义的链接。定义以表格的形式显示以便于在需要时修改。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点击链接来维护报告标题，它显示已经定义的报告的标题设置项，以供修改或者运行。要运行报告，只要简单地点击</FONT></FONT><FONT COLOR="#000000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>产生</FONT></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT COLOR="#000000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">PDF</SPAN></FONT></FONT></FONT></SPAN></FONT><FONT COLOR="#000000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告的</FONT></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>连接。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>这些销售报告必须查询很多信息（报告通常是动态生成的），因此，他们可以花大约一分钟在大型数据库运行。然而，数据经过精心的设计，因而确保能够以比很多类似分析引擎快得多的速度动态生成报告。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>可能值得举一个生成报告的例子－－为每个销售地区和该地区的销售人员，显示其销售额和毛利润，</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>应收账款－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&gt;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>查询和报告－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&gt;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>销售分析报告</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在定义一新报告－－报告标题处</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR></SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>输入标题&ldquo;销售－以地区和销售人员分类&rdquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>选择销售地区作为&ldquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">Group
By 1&quot;
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>然后在&ldquo;起始&rdquo;框输入</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>0</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>－－由于所有的销售地区编号都会大于</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">0</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，然后在&ldquo;截止&rdquo;框输入&rdquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ZZZZZ&quot;--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>希望你定义的销售地区代码落在</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">0</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>到</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ZZZZZ</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>之间</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>如果您只要某一个地区，那么只要在&ldquo;起始&rdquo;和&ldquo;截止&rdquo;框中都输入该代码即可。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><BR>
</P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>选择&ldquo;销售人员&rdquo;作为&ldquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">Group
By 2&quot;
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>然后在&ldquo;起始&rdquo;框输入</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">0</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>－－由于所有的销售员编号都会大于</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">0</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，然后在&ldquo;截止&rdquo;框输入&rdquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ZZZZZ&quot;--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>希望你定义的销售员代码落在</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">0</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>到</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ZZZZZ</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>之间</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>如果您只要某一个销售员，那么只要在&ldquo;起始&rdquo;和&ldquo;截止&rdquo;框中都输入该代码即可。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><BR>
</P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点击输入信息将此报告输入数据库。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告清单会显示我们的新报告&ldquo;销售－依地区和销售员&rdquo;－－点击定义列的连</FONT></FONT></P>
<P STYLE="margin-bottom: 0cm"><BR>
</P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>接下来定义此报告的列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><BR>
</P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在列数中输入列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">1</SPAN></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN STYLE="font-weight: normal">标题</SPAN></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><SPAN STYLE="font-weight: normal">1</SPAN></SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN STYLE="font-weight: normal">输入－&ldquo;销售额&rdquo;－－这是列标题的头一行</SPAN></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>标题</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>输入－&ldquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">January
08&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>这是列标题的第二行</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>现在查找</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">January
08</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>所属期间数，然后在</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>起始期间</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>和&ldquo;截止期间</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>输入期间数；</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>如果您要显示一个期间范围的销售额，你可以选择任何期间范围－－只要确保</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>截止期间</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在</FONT></FONT><FONT COLOR="#ff0000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>开始期间</FONT></FONT></FONT><FONT COLOR="#ff0000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>之后！</FONT></FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>
由于我们要显示</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>1</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>月份的销售额，在</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>
&ldquo;</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>显示数据&rdquo;
选择框内。我们需要选择&ldquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">Net
Sales
Value&quot;&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>净销售额&ldquo;，这个列可以包含选择框内任何可选的数据。毛销售额选项是在计入销售折扣之前的销售额－－大多数情形下，您需要净销售额。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>预算或者实际金额框需要从预算改为实际。如果你要比较预算金额，那么销售预算需要导入。（目前没有界面可以让用户手动输入预算）。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点击输入信息</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">,</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>系统</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>会在页头显示单列的定义，以及用来加入新列的新空白列。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>要</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>为一月份的毛利润创建另一列－－如同上面一样－－只需输入栏</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，并且把标题文字从销售额改为毛利润－－使用同样的期间范围。这次在&ldquo;显示数据&rdquo;中选择&ldquo;毛利润&rdquo;；以及预算栏或者实际中选&ldquo;实际&rdquo;。再次点击输入信息来接受第二列－－定义的两列会显示在屏幕上。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>现在运行报告，点击&ldquo;维护报告标题&rdquo;连接，查看已经定义的报告列表，寻找&ldquo;销售－－以区域和销售员&rdquo;报告，点击链接&ldquo;生成</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">PDF</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告&rdquo;&ldquo;</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>系统会运行报告，一个</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">pdf</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告会被显示。。。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR><BR></SPAN></FONT></SPAN></FONT><FONT COLOR="#000000"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=5 STYLE="font-size: 20pt"><B>计算字段的例子</B></FONT></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>例如，列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">1</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>表示</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2008</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>年一月的销售额，列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>表示</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2007</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>年一月的销售额－－我们希望有第三列，显示今年销售额占去年的百分比。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>要定义列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">3</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>：输入列号－－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">3</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>和列标题－－比去年增加的</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">%</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，选择计算</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">--Yes,
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>然后</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点击输入信息按钮</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">Enter
Information
Button--</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>表单于是显示&ldquo;分子列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">#&quot;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>和分母列＃&ldquo;。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>今年的销售应该是分子列－－列</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">1</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>－－在这栏输入</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">1</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>。分母列为</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">2</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>计算类型应是分子被分母除。也有其他的选项。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>这个计算的格式应该是百分数。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=5 STYLE="font-size: 20pt"><B>自动的销售报告</B></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR></SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>创建了报告后，可以把销售报告电邮至定义的收信人那里。脚本</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">MailSalesReport.php</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>是一个模板。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>webERP</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>没有设置到此脚本的链接，并且也没有为它设置安全水准。唯一要求的是把此脚本另存为其他名字，用</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">.php</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>为后缀，且与其他脚本在同一路径下。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT></SPAN></FONT><BR>
</P>
<P STYLE="margin-bottom: 0cm"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>脚本需要编辑收件人的电邮地址和报告ＩＤ－－系统产生的要运行的报告编号。要编辑的行是：</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/*</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>要发送的销售报告</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">*/</SPAN></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR>$ReportID
= 4;<BR><BR></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/*</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>收到电邮报告的人员</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>*</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/</SPAN></FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR>$Recipients
= array('&quot;Root&quot; ','&quot;some one else&quot; ');
<BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>以</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/*</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>和</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">*/</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>包围的行称为注释。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>一旦编辑或选择了</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ReportID</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>，输入了收件人，就可以储存文件了。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>在</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">linux</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>环境下，</FONT></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>计划在每个工作日的</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>0:0</FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>点，运行</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">crontab</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>中设置的计划报告（假设</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">wget</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>安装在</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">/usr/bin/wget
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>并且网页服务器在同一机器上，新脚本称为</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">DailySalesReport.php),</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>那么应是这样：</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR>#
Scheduled email of a daily sales report </SPAN></FONT></SPAN></FONT>　<FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>有计划地发送每天的销售报告</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR>0
0 * * 2-5 root /usr/bin/wget
http://localhost/web-erp/DailySalesReport.php
<BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>由于这页没有输出－－在网页浏览器中运行它没有意义，尽管它会发送另外一个电邮到定义的收件人那里。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>有一个相似的模板脚本叫</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">MailSalesReport_csv.php,</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>他会为一个</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">ReportID</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>邮寄</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">csv</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件给收件人。</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><BR><BR></SPAN></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>自动邮寄销售分析报告的另外一个优雅的解决方案，是使用脚本</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">report_runner.php</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>。可以从</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">shell</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>或者</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">cron</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>直接运行，并采用命令行参数。它的优点在于不用写死一个号码或者脚本，这个脚本可以用以下的命令行运行：</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR>-r
reportnumber (the number of the webERP report) -r </SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告编号
（</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">webERP</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>的报告编号）</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR>-n
reportname (the name you want to give the report) </SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">n
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告名称
（你赋予的报告名）</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR>-e
emailaddress[;emailaddress;emailaddres...] (who you want to send it
to) -e </SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>电邮地址</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">[;</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>电邮地址；电邮地址。。。］（你要发送的收件人）</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR>[-t
reporttext ] (some words you want to send with the report-optional)
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>［－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">t
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>报告文字］（你随报告要发送的文字－可选）</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US"><BR>[
-H weberpHOME] (the home directory for weberp - or edit the php file)
</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>［－</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">H
weberpHome](webERP</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>的家目录－或者编辑</FONT></FONT><FONT FACE="Times New Roman, serif"><SPAN LANG="en-US"><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4><SPAN LANG="en-US">php</SPAN></FONT></FONT></SPAN></FONT><FONT FACE="楷体_GB2312, monospace"><FONT SIZE=4>文件）</FONT></FONT></P>
<P STYLE="margin-bottom: 0cm"><BR>
</P>
</BODY>
</HTML>